/*
 Navicat Premium Data Transfer

 Source Server         : 华为云
 Source Server Type    : MySQL
 Source Server Version : 80032
 Source Host           : 123.60.140.66:3306
 Source Schema         : yrmall_oms

 Target Server Type    : MySQL
 Target Server Version : 80032
 File Encoding         : 65001

 Date: 03/08/2023 16:29:45
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for oms_order
-- ----------------------------
DROP TABLE IF EXISTS `oms_order`;
CREATE TABLE `oms_order` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `order_sn` varchar(255) DEFAULT NULL COMMENT '订单号',
  `coupon_id` bigint DEFAULT NULL COMMENT '使用的优惠券',
  `total_amount` decimal(18,2) NOT NULL COMMENT '订单总额',
  `pay_amount` decimal(18,2) NOT NULL COMMENT '应付总额',
  `coupon_amount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '优惠券抵扣金额',
  `integration_amount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '积分抵扣金额',
  `freight_amount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '运费金额',
  `member_id` bigint NOT NULL COMMENT 'member_id',
  `member_username` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '用户名',
  `pay_type` tinyint DEFAULT '0' COMMENT '支付方式',
  `status` tinyint NOT NULL COMMENT '订单状态【0->待付款；1->待发货；2->已发货；3->已完成；4->已关闭；5->无效订单】',
  `delivery_sn` varchar(64) DEFAULT NULL COMMENT '物流单号',
  `auto_confirm_day` int NOT NULL DEFAULT '7' COMMENT '自动确认时间（天）',
  `integration` int NOT NULL DEFAULT '0' COMMENT '可以获得的积分',
  `growth` int NOT NULL COMMENT '可以获得的成长值',
  `receiver_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '收货人姓名',
  `receiver_phone` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '收货人电话',
  `receiver_post_code` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '收货人邮编',
  `receiver_province` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '省份/直辖市',
  `receiver_city` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '城市',
  `receiver_region` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '区',
  `receiver_detail_address` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '详细地址',
  `note` varchar(500) DEFAULT NULL COMMENT '订单备注',
  `use_integration` int NOT NULL DEFAULT '0' COMMENT '下单时使用的积分',
  `payment_time` datetime DEFAULT NULL COMMENT '支付时间',
  `delivery_time` datetime DEFAULT NULL COMMENT '发货时间',
  `receive_time` datetime DEFAULT NULL COMMENT '确认收货时间',
  `delivery_company` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '物流公司',
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `update_by` varchar(255) DEFAULT NULL,
  `version` int NOT NULL DEFAULT '0',
  `is_deleted` bit(1) NOT NULL DEFAULT b'0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1686775104847572995 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='订单';

-- ----------------------------
-- Records of oms_order
-- ----------------------------
BEGIN;
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1672128594158157826, '20230623142457651308', NULL, 30398.00, 30404.00, 0.00, 0.00, 0.00, 1, 'Leron', 0, 0, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-06-23 14:24:58', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1672128620741656578, '20230623142504567132', NULL, 30398.00, 30404.00, 0.00, 0.00, 0.00, 1, 'Leron', 0, 0, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-06-23 14:25:04', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674793487063822337, '20230630225417523815', NULL, 30398.00, 30404.00, 0.00, 0.00, 0.00, 1, 'Leron', 0, 0, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-06-30 22:54:18', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674794580124610562, '20230630225838596286', NULL, 30398.00, 30404.00, 0.00, 0.00, 0.00, 1, 'Leron', 0, 0, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-06-30 22:58:39', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674794724467388418, '20230630225912272671', NULL, 30398.00, 30404.00, 0.00, 0.00, 0.00, 1, 'Leron', 0, 0, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-06-30 22:59:13', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674794811675357186, '20230630225933401705', NULL, 30398.00, 30404.00, 0.00, 0.00, 0.00, 1, 'Leron', 0, 0, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-06-30 22:59:34', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674795396399083521, '20230630230153301503', NULL, 30398.00, 30404.00, 0.00, 0.00, 0.00, 1, 'Leron', 0, 0, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-06-30 23:01:53', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674796040161832962, '20230630230426347101', NULL, 30398.00, 30404.00, 0.00, 0.00, 0.00, 1, 'Leron', 0, 0, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-06-30 23:04:27', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674796117362192385, '20230630230445752947', NULL, 30398.00, 30404.00, 0.00, 0.00, 0.00, 1, 'Leron', 0, 0, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-06-30 23:04:45', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674796239038951425, '20230630230514562374', NULL, 30398.00, 30404.00, 0.00, 0.00, 0.00, 1, 'Leron', 0, 0, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-06-30 23:05:14', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674802039169986561, '20230630232816243948', NULL, 30398.00, 30404.00, 0.00, 0.00, 0.00, 1, 'Leron', 0, 0, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-06-30 23:28:17', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1675079113457762305, '20230701174916827816', NULL, 6200.00, 6206.00, 0.00, 0.00, 0.00, 1, 'Leron', 0, 0, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-07-01 17:49:17', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1675422880538771458, '20230702163517614692', NULL, 7999.00, 8005.00, 0.00, 0.00, 0.00, 1, 'Leron', 0, 4, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-07-02 16:35:17', 'Leron', '2023-07-02 16:56:59', '-1', 1, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1675479592037761026, '20230702202038059884', NULL, 7999.00, 8005.00, 0.00, 0.00, 0.00, 1, 'Leron', 0, 4, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-07-02 20:20:38', 'Leron', '2023-07-02 20:20:49', '-1', 1, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1678412263785197569, '20230710223401116813', NULL, 7999.00, 7999.00, 0.00, 0.00, 0.00, 1, 'Leron', 0, 4, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-07-10 22:34:02', 'Leron', '2023-07-10 22:34:12', '-1', 1, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1678414242137722882, '20230710224120624642', NULL, 7999.00, 7999.00, 0.00, 0.00, 0.00, 1, 'Leron', 0, 4, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-07-10 22:41:53', 'Leron', '2023-07-10 22:42:04', '-1', 1, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1678419930444402689, '20230710230429247511', 1675525101238497281, 7999.00, 7699.00, 300.00, 0.00, 0.00, 1, 'Leron', 0, 4, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-07-10 23:04:30', 'Leron', '2023-07-10 23:04:40', '-1', 1, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1678419975390564354, '20230710230440248431', 1675525101238497281, 7999.00, 7699.00, 300.00, 0.00, 0.00, 1, 'Leron', 0, 4, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-07-10 23:04:40', 'Leron', '2023-07-10 23:04:51', '-1', 1, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1678420027978747906, '20230710230452050911', 1671818392838057985, 7999.00, 7969.00, 30.00, 0.00, 0.00, 1, 'Leron', 0, 4, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-07-10 23:04:53', 'Leron', '2023-07-10 23:05:03', '-1', 1, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1678420071226216450, '20230710230502786341', 1674417822346997761, 7999.00, 7969.00, 30.00, 0.00, 0.00, 1, 'Leron', 0, 4, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-07-10 23:05:03', 'Leron', '2023-07-10 23:05:14', '-1', 1, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1685307967145119746, '20230729231505946095', NULL, 7999.00, 7999.00, 0.00, 0.00, 0.00, 1, 'Leron', 0, 4, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-07-29 23:15:06', 'Leron', '2023-07-29 23:15:16', '-1', 1, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1685521495835688961, '20230730132334940782', NULL, 7999.00, 7999.00, 0.00, 0.00, 0.00, 1, 'Leron', 0, 4, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-07-30 13:23:35', 'Leron', '2023-07-30 13:23:45', '-1', 1, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1685522954748940289, '20230730132922332715', NULL, 7999.00, 7999.00, 0.00, 0.00, 0.00, 1, 'Leron', 0, 4, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-07-30 13:29:23', 'Leron', '2023-07-30 13:59:23', '-1', 1, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1685523153336651778, '20230730133009166885', NULL, 7999.00, 7999.00, 0.00, 0.00, 0.00, 1, 'Leron', 2, 1, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-07-30 13:30:10', 'Leron', '2023-07-30 13:31:48', 'Leron', 1, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1685523815562727425, '20230730133247596514', NULL, 7999.00, 7999.00, 0.00, 0.00, 0.00, 1, 'Leron', 2, 1, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-07-30 13:32:48', 'Leron', '2023-07-30 13:32:51', 'Leron', 1, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1686383443498467330, '20230801222838580250', 1686382736376471554, 7999.00, 7699.00, 300.00, 0.00, 0.00, 1, 'Leron', 0, 4, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-08-01 22:28:39', 'Leron', '2023-08-01 22:58:40', '-1', 1, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1686387069939843073, '20230801224303779797', 1686377395865694210, 7999.00, 7969.00, 30.00, 0.00, 0.00, 1, 'Leron', 0, 0, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-08-01 22:43:04', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order` (`id`, `order_sn`, `coupon_id`, `total_amount`, `pay_amount`, `coupon_amount`, `integration_amount`, `freight_amount`, `member_id`, `member_username`, `pay_type`, `status`, `delivery_sn`, `auto_confirm_day`, `integration`, `growth`, `receiver_name`, `receiver_phone`, `receiver_post_code`, `receiver_province`, `receiver_city`, `receiver_region`, `receiver_detail_address`, `note`, `use_integration`, `payment_time`, `delivery_time`, `receive_time`, `delivery_company`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1686387896230313986, '20230801224620420214', NULL, 7999.00, 7999.00, 0.00, 0.00, 0.00, 1, 'Leron', 0, 0, NULL, 7, 0, 0, '利若', '15615001223', '000000', '山东省', '菏泽市', '成武县', '金枫南路蓝光和雍锦园', NULL, 0, NULL, NULL, NULL, NULL, '2023-08-01 22:46:21', 'Leron', NULL, NULL, 0, b'0');
COMMIT;

-- ----------------------------
-- Table structure for oms_order_item
-- ----------------------------
DROP TABLE IF EXISTS `oms_order_item`;
CREATE TABLE `oms_order_item` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `order_id` bigint NOT NULL COMMENT 'order_id',
  `order_sn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'order_sn',
  `spu_id` bigint NOT NULL COMMENT 'spu_id',
  `spu_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'spu_name',
  `spu_pic` varchar(500) DEFAULT NULL COMMENT 'spu_pic',
  `sku_id` bigint NOT NULL COMMENT '商品sku编号',
  `sku_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '商品sku名字',
  `sku_pic` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '商品sku图片',
  `sku_price` decimal(18,2) NOT NULL COMMENT '商品sku价格',
  `sku_quantity` int NOT NULL COMMENT '商品购买的数量',
  `sku_attrs_vals` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '商品销售属性组合',
  `promotion_amount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '商品促销分解金额',
  `coupon_amount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '优惠券优惠分解金额',
  `integration_amount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '积分优惠分解金额',
  `total_amount` varchar(255) NOT NULL COMMENT '商品总金额',
  `real_amount` decimal(18,2) NOT NULL COMMENT '该商品经过优惠后的分解金额',
  `gift_integration` int NOT NULL DEFAULT '0' COMMENT '赠送积分',
  `gift_growth` int NOT NULL DEFAULT '0' COMMENT '赠送成长值',
  `remark` varchar(255) DEFAULT NULL COMMENT '订单备注',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '订单状态',
  `create_time` datetime DEFAULT NULL,
  `create_by` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `update_by` varchar(255) DEFAULT NULL,
  `version` int NOT NULL DEFAULT '0',
  `is_deleted` bit(1) NOT NULL DEFAULT b'0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1686775104965013507 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='订单项信息';

-- ----------------------------
-- Records of oms_order_item
-- ----------------------------
BEGIN;
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1672128594304958465, 1672128594158157826, '20230623142457651308', 1647522980002193410, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机', NULL, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643bb4f9bdb42ef8f0abd79b.jpg', 6200.00, 2, '外观:曜金黑;内存:256G;版本:优惠套装', 0.00, 0.00, 0.00, '12400.00', 12400.00, 0, 0, NULL, 0, '2023-06-23 14:24:58', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1672128594447564802, 1672128594158157826, '20230623142457651308', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', NULL, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 7999.00, 1, '外观:土豪黄;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-06-23 14:24:58', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1672128594594365441, 1672128594158157826, '20230623142457651308', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', NULL, 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 9999.00, 1, '外观:土豪黄;内存:512G;版本:标准版', 0.00, 0.00, 0.00, '9999.00', 9999.00, 0, 0, NULL, 0, '2023-06-23 14:24:58', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1672128620888457218, 1672128620741656578, '20230623142504567132', 1647522980002193410, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机', NULL, 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643bb4f9bdb42ef8f0abd79b.jpg', 6200.00, 2, '外观:曜金黑;内存:256G;版本:优惠套装', 0.00, 0.00, 0.00, '12400.00', 12400.00, 0, 0, NULL, 0, '2023-06-23 14:25:05', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1672128621043646466, 1672128620741656578, '20230623142504567132', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', NULL, 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 7999.00, 1, '外观:土豪黄;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-06-23 14:25:05', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1672128621194641410, 1672128620741656578, '20230623142504567132', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', NULL, 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 9999.00, 1, '外观:土豪黄;内存:512G;版本:标准版', 0.00, 0.00, 0.00, '9999.00', 9999.00, 0, 0, NULL, 0, '2023-06-23 14:25:05', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674793487231594498, 1674793487063822337, '20230630225417523815', 1647522980002193410, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd78f.jpg', 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643bb4f9bdb42ef8f0abd79b.jpg', 6200.00, 2, '外观:曜金黑;内存:256G;版本:优惠套装', 0.00, 0.00, 0.00, '12400.00', 12400.00, 0, 0, NULL, 0, '2023-06-30 22:54:18', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674793487386783746, 1674793487063822337, '20230630225417523815', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 7999.00, 1, '外观:土豪黄;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-06-30 22:54:18', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674793487554555906, 1674793487063822337, '20230630225417523815', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 9999.00, 1, '外观:土豪黄;内存:512G;版本:标准版', 0.00, 0.00, 0.00, '9999.00', 9999.00, 0, 0, NULL, 0, '2023-06-30 22:54:18', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674794580397240322, 1674794580124610562, '20230630225838596286', 1647522980002193410, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd78f.jpg', 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643bb4f9bdb42ef8f0abd79b.jpg', 6200.00, 2, '外观:曜金黑;内存:256G;版本:优惠套装', 0.00, 0.00, 0.00, '12400.00', 12400.00, 0, 0, NULL, 0, '2023-06-30 22:58:39', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674794580544040961, 1674794580124610562, '20230630225838596286', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 7999.00, 1, '外观:土豪黄;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-06-30 22:58:39', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674794580686647298, 1674794580124610562, '20230630225838596286', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 9999.00, 1, '外观:土豪黄;内存:512G;版本:标准版', 0.00, 0.00, 0.00, '9999.00', 9999.00, 0, 0, NULL, 0, '2023-06-30 22:58:39', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674794724630966273, 1674794724467388418, '20230630225912272671', 1647522980002193410, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd78f.jpg', 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643bb4f9bdb42ef8f0abd79b.jpg', 6200.00, 2, '外观:曜金黑;内存:256G;版本:优惠套装', 0.00, 0.00, 0.00, '12400.00', 12400.00, 0, 0, NULL, 0, '2023-06-30 22:59:13', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674794724794544129, 1674794724467388418, '20230630225912272671', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 7999.00, 1, '外观:土豪黄;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-06-30 22:59:13', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674794725021036546, 1674794724467388418, '20230630225912272671', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 9999.00, 1, '外观:土豪黄;内存:512G;版本:标准版', 0.00, 0.00, 0.00, '9999.00', 9999.00, 0, 0, NULL, 0, '2023-06-30 22:59:13', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674794811968958466, 1674794811675357186, '20230630225933401705', 1647522980002193410, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd78f.jpg', 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643bb4f9bdb42ef8f0abd79b.jpg', 6200.00, 2, '外观:曜金黑;内存:256G;版本:优惠套装', 0.00, 0.00, 0.00, '12400.00', 12400.00, 0, 0, NULL, 0, '2023-06-30 22:59:34', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674794812241588225, 1674794811675357186, '20230630225933401705', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 7999.00, 1, '外观:土豪黄;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-06-30 22:59:34', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674794812547772417, 1674794811675357186, '20230630225933401705', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 9999.00, 1, '外观:土豪黄;内存:512G;版本:标准版', 0.00, 0.00, 0.00, '9999.00', 9999.00, 0, 0, NULL, 0, '2023-06-30 22:59:34', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674795396579438594, 1674795396399083521, '20230630230153301503', 1647522980002193410, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd78f.jpg', 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643bb4f9bdb42ef8f0abd79b.jpg', 6200.00, 2, '外观:曜金黑;内存:256G;版本:优惠套装', 0.00, 0.00, 0.00, '12400.00', 12400.00, 0, 0, NULL, 0, '2023-06-30 23:01:53', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674795396738822145, 1674795396399083521, '20230630230153301503', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 7999.00, 1, '外观:土豪黄;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-06-30 23:01:53', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674795396898205698, 1674795396399083521, '20230630230153301503', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 9999.00, 1, '外观:土豪黄;内存:512G;版本:标准版', 0.00, 0.00, 0.00, '9999.00', 9999.00, 0, 0, NULL, 0, '2023-06-30 23:01:53', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674796040434462721, 1674796040161832962, '20230630230426347101', 1647522980002193410, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd78f.jpg', 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643bb4f9bdb42ef8f0abd79b.jpg', 6200.00, 2, '外观:曜金黑;内存:256G;版本:优惠套装', 0.00, 0.00, 0.00, '12400.00', 12400.00, 0, 0, NULL, 0, '2023-06-30 23:04:27', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674796040606429185, 1674796040161832962, '20230630230426347101', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 7999.00, 1, '外观:土豪黄;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-06-30 23:04:27', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674796040820338690, 1674796040161832962, '20230630230426347101', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 9999.00, 1, '外观:土豪黄;内存:512G;版本:标准版', 0.00, 0.00, 0.00, '9999.00', 9999.00, 0, 0, NULL, 0, '2023-06-30 23:04:27', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674796117513187329, 1674796117362192385, '20230630230445752947', 1647522980002193410, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd78f.jpg', 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643bb4f9bdb42ef8f0abd79b.jpg', 6200.00, 2, '外观:曜金黑;内存:256G;版本:优惠套装', 0.00, 0.00, 0.00, '12400.00', 12400.00, 0, 0, NULL, 0, '2023-06-30 23:04:45', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674796117659987969, 1674796117362192385, '20230630230445752947', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 7999.00, 1, '外观:土豪黄;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-06-30 23:04:45', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674796117915840513, 1674796117362192385, '20230630230445752947', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 9999.00, 1, '外观:土豪黄;内存:512G;版本:标准版', 0.00, 0.00, 0.00, '9999.00', 9999.00, 0, 0, NULL, 0, '2023-06-30 23:04:45', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674796239185752065, 1674796239038951425, '20230630230514562374', 1647522980002193410, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd78f.jpg', 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643bb4f9bdb42ef8f0abd79b.jpg', 6200.00, 2, '外观:曜金黑;内存:256G;版本:优惠套装', 0.00, 0.00, 0.00, '12400.00', 12400.00, 0, 0, NULL, 0, '2023-06-30 23:05:14', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674796239332552706, 1674796239038951425, '20230630230514562374', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 7999.00, 1, '外观:土豪黄;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-06-30 23:05:14', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674796239479353345, 1674796239038951425, '20230630230514562374', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 9999.00, 1, '外观:土豪黄;内存:512G;版本:标准版', 0.00, 0.00, 0.00, '9999.00', 9999.00, 0, 0, NULL, 0, '2023-06-30 23:05:14', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674802039413256194, 1674802039169986561, '20230630232816243948', 1647522980002193410, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd78f.jpg', 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643bb4f9bdb42ef8f0abd79b.jpg', 6200.00, 2, '外观:曜金黑;内存:256G;版本:优惠套装', 0.00, 0.00, 0.00, '12400.00', 12400.00, 0, 0, NULL, 0, '2023-06-30 23:28:17', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674802039560056834, 1674802039169986561, '20230630232816243948', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 7999.00, 1, '外观:土豪黄;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-06-30 23:28:17', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1674802039719440386, 1674802039169986561, '20230630232816243948', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519696118013954, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 512G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 9999.00, 1, '外观:土豪黄;内存:512G;版本:标准版', 0.00, 0.00, 0.00, '9999.00', 9999.00, 0, 0, NULL, 0, '2023-06-30 23:28:17', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1675079113604562945, 1675079113457762305, '20230701174916827816', 1647522980002193410, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd78f.jpg', 1647522988067840001, 'HUAWEI Mate 50 直屏旗舰 超可靠昆仑玻璃 超光变XMAGE影像 北斗卫星消息 256GB冰霜银 华为鸿蒙手机 曜金黑 256G 优惠套装', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643bb4f9bdb42ef8f0abd79b.jpg', 6200.00, 1, '外观:曜金黑;内存:256G;版本:优惠套装', 0.00, 0.00, 0.00, '6200.00', 6200.00, 0, 0, NULL, 0, '2023-07-01 17:49:17', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1675422880689766402, 1675422880538771458, '20230702163517614692', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 7999.00, 1, '外观:暗紫色;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-07-02 16:35:17', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1675479592276836354, 1675479592037761026, '20230702202038059884', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 7999.00, 1, '外观:暗紫色;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-07-02 20:20:38', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1678412263915220994, 1678412263785197569, '20230710223401116813', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 7999.00, 1, '外观:暗紫色;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-07-10 22:34:02', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1678414242397769729, 1678414242137722882, '20230710224120624642', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 7999.00, 1, '外观:暗紫色;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-07-10 22:41:53', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1678419930683478017, 1678419930444402689, '20230710230429247511', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 7999.00, 1, '外观:暗紫色;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-07-10 23:04:30', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1678419975549947905, 1678419975390564354, '20230710230440248431', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 7999.00, 1, '外观:暗紫色;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-07-10 23:04:40', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1678420028154908673, 1678420027978747906, '20230710230452050911', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 7999.00, 1, '外观:暗紫色;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-07-10 23:04:53', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1678420071448514562, 1678420071226216450, '20230710230502786341', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 7999.00, 1, '外观:暗紫色;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-07-10 23:05:03', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1685307967375806465, 1685307967145119746, '20230729231505946095', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 7999.00, 1, '外观:暗紫色;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-07-29 23:15:06', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1685521496041209858, 1685521495835688961, '20230730132334940782', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 7999.00, 1, '外观:暗紫色;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-07-30 13:23:35', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1685522955008987138, 1685522954748940289, '20230730132922332715', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 7999.00, 1, '外观:土豪黄;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, '不要葱花', 0, '2023-07-30 13:29:23', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1685523153504423938, 1685523153336651778, '20230730133009166885', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519694947803138, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 土豪黄 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba80bbdb42ef8f0abd797.png', 7999.00, 1, '外观:土豪黄;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-07-30 13:30:10', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1685523815726305282, 1685523815562727425, '20230730133247596514', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 7999.00, 1, '外观:暗紫色;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-07-30 13:32:48', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1686383443712376834, 1686383443498467330, '20230801222838580250', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 7999.00, 1, '外观:暗紫色;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-08-01 22:28:39', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1686387070095032321, 1686387069939843073, '20230801224303779797', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 7999.00, 1, '外观:暗紫色;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-08-01 22:43:04', 'Leron', NULL, NULL, 0, b'0');
INSERT INTO `oms_order_item` (`id`, `order_id`, `order_sn`, `spu_id`, `spu_name`, `spu_pic`, `sku_id`, `sku_name`, `sku_pic`, `sku_price`, `sku_quantity`, `sku_attrs_vals`, `promotion_amount`, `coupon_amount`, `integration_amount`, `total_amount`, `real_amount`, `gift_integration`, `gift_growth`, `remark`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `version`, `is_deleted`) VALUES (1686387896393891842, 1686387896230313986, '20230801224620420214', 1647519689088360450, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 1647519692183756801, 'Apple iPhone 14 Pro (A2892) 128GB 暗紫色 支持移动联通电信5G 双卡双待手机 暗紫色 256G 标准版', 'https://leron-public.oss-cn-qingdao.aliyuncs.com/xymall/643ba9a0bdb42ef8f0abd79a.jpg', 7999.00, 1, '外观:暗紫色;内存:256G;版本:标准版', 0.00, 0.00, 0.00, '7999.00', 7999.00, 0, 0, NULL, 0, '2023-08-01 22:46:21', 'Leron', NULL, NULL, 0, b'0');
COMMIT;

-- ----------------------------
-- Table structure for oms_order_return_apply
-- ----------------------------
DROP TABLE IF EXISTS `oms_order_return_apply`;
CREATE TABLE `oms_order_return_apply` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `order_id` bigint NOT NULL COMMENT 'order_id',
  `item_id` int NOT NULL COMMENT 'order_item_id',
  `sku_id` bigint NOT NULL COMMENT '退货商品id',
  `order_sn` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '订单编号',
  `member_username` varchar(64) DEFAULT NULL COMMENT '会员用户名',
  `return_amount` decimal(18,4) NOT NULL COMMENT '退款金额',
  `return_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '退货人姓名',
  `return_phone` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '退货人电话',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '申请状态[0->待处理；1->退货中；2->已完成；3->已拒绝]',
  `handle_time` datetime NOT NULL COMMENT '处理时间',
  `sku_img` varchar(500) DEFAULT NULL COMMENT '商品图片',
  `sku_name` varchar(200) DEFAULT NULL COMMENT '商品名称',
  `sku_attrs_vals` varchar(500) DEFAULT NULL COMMENT '商品销售属性(JSON)',
  `refund_count` int NOT NULL COMMENT '退货数量',
  `sku_price` decimal(18,4) NOT NULL COMMENT '商品单价',
  `sku_real_price` decimal(18,4) NOT NULL COMMENT '商品实际支付单价',
  `reason` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '退货原因',
  `receive_man` varchar(100) DEFAULT NULL COMMENT '收货人',
  `receive_time` datetime DEFAULT NULL COMMENT '收货时间',
  `receive_note` varchar(500) DEFAULT NULL COMMENT '收货备注',
  `receive_phone` varchar(20) DEFAULT NULL COMMENT '收货电话',
  `create_time` datetime NOT NULL COMMENT '申请时间',
  `create_by` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `update_by` varchar(255) DEFAULT NULL,
  `is_deleted` bit(1) NOT NULL DEFAULT b'0',
  `version` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='订单退货申请';

-- ----------------------------
-- Records of oms_order_return_apply
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for oms_refund_info
-- ----------------------------
DROP TABLE IF EXISTS `oms_refund_info`;
CREATE TABLE `oms_refund_info` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `order_return_id` bigint DEFAULT NULL COMMENT '退款的订单',
  `refund` decimal(18,4) DEFAULT NULL COMMENT '退款金额',
  `refund_sn` varchar(64) DEFAULT NULL COMMENT '退款交易流水号',
  `refund_status` tinyint(1) DEFAULT NULL COMMENT '退款状态',
  `refund_channel` tinyint DEFAULT NULL COMMENT '退款渠道[1-支付宝，2-微信，3-银联，4-汇款]',
  `refund_content` varchar(5000) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='退款信息';

-- ----------------------------
-- Records of oms_refund_info
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for undo_log
-- ----------------------------
DROP TABLE IF EXISTS `undo_log`;
CREATE TABLE `undo_log` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `branch_id` bigint NOT NULL,
  `xid` varchar(100) NOT NULL,
  `context` varchar(128) NOT NULL,
  `rollback_info` longblob NOT NULL,
  `log_status` int NOT NULL,
  `log_created` datetime NOT NULL,
  `log_modified` datetime NOT NULL,
  `ext` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `ux_undo_log` (`xid`,`branch_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of undo_log
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
